<?php
    include 'header.php';
  ?>
<?php
$myid=$_GET['myarg'];
//echo "it is $myid";

//echo "This page is under construction..."
$username = "fossilplot";
$password = "fossilplot";
$hostname = "localhost"; 

//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password)
 or die("Unable to connect to MySQL");


//select a database to work with
$selected = mysql_select_db("fossilplot",$dbhandle)
  or die("Could not select examples");
  echo "Here is the details of this genus:<br><br>";
$name=mysql_query("select * from genus where id=$myid") or die ("error selecting from stgintv!!");
echo "<table border=1>
<tr><td>ID</td><td>Genus Name</td><td>Phylum Name</td><td>Class Name</td><td>Order Name</td><td>Fad Period</td><td>Fad Stage</td><td>Fad Date</td><td>Lad Period</td><td>Lad Stage</td><td>Lad Date</td></tr>
";
echo "<tr>";
while($row=mysql_fetch_array($name)){
echo "<td>".$row{'id'}."</td><td>".$row{'genus_name'}."</td><td>".$row{'phylum_name'}."</td><td>".$row{'class_name'}."</td><td>".$row{'order_name'}."</td><td>".$row{'fad_period'}."</td><td>".$row{'fad_stage'}."</td><td>".$row{'fad_date'}."</td><td>".$row{'lad_period'}."</td><td>".$row{'lad_stage'}."</td><td>".$row{'lad_date'}."</td></tr>";
}
echo "</table>";

?>

<?php
    include 'footer.php';
  ?>